SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 37681: A "LIBNAME not found" error occurs when you add an export definition that references a library that is defined in the mausrexp macro

DetailsAboutRate It

SAS® Customer Intelligence has a user-customizable macro file mausrexp.sas in which libraries can be defined for use in export definitions. If a library that is defined in this macro file uses the SAS/ACCESS® Interface to Oracle engine, then the library's definition must be in all uppercase characters. If the definition is not in all uppercase characters, then an error might occur:

LIBNAME not found

The error occurs when the library is referenced in an export definition in the SAS® Management Console SAS® Customer Intelligence export definition Plug-in.

This problem occurs because there is a typo in the mausrexp.sas macro file. In the line that defines the acceptable characters, the lowercase "o" is missing. There is a "u" where the "o" should be. Therefore, any library name that contains a lowercase "o" is considered invalid.

There are two ways to work around this problem.

  1. Edit the following line in the mausrexp.sas macro file. Change the line from this:

    %let first=ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnupqrstuvwxyz_;

    to this:

    %let first=ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_;

  2. make sure that the library name is in all uppercase characters.

The mausrexp.sas macro file can be found here:

  • For Windows systems: {SAS_BASE}\SASFoundation\9.2\ma\sasmacro
  • For UNIX systems: {SAS_BASE}/SASFoundation/9.2/sasautos


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence Plug-ins for SAS Management ConsoleMicrosoft® Windows® for x645.35.3_M39.2 TS2M29.2 TS2M3
Microsoft Windows Server 2003 Datacenter Edition5.35.3_M39.2 TS2M29.2 TS2M3
Microsoft Windows Server 2003 Standard Edition5.35.3_M39.2 TS2M29.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition5.35.3_M39.2 TS2M29.2 TS2M3
Microsoft Windows XP Professional5.35.3_M39.2 TS2M29.2 TS2M3
Microsoft Windows Server 20085.35.3_M39.2 TS2M29.2 TS2M3
HP-UX IPF5.35.3_M39.2 TS2M29.2 TS2M3
64-bit Enabled Solaris5.35.3_M39.2 TS2M29.2 TS2M3
64-bit Enabled AIX5.35.3_M39.2 TS2M29.2 TS2M3
Windows Vista5.35.3_M39.2 TS2M29.2 TS2M3
Linux for x645.35.3_M39.2 TS2M29.2 TS2M3
Solaris for x645.35.3_M39.2 TS2M29.2 TS2M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.